1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Views
13 {
14 public partial class uctKhachHang : UserControl
15 {
16 public uctKhachHang()
17 {
18 InitializeComponent();
19 }
20 public static uctKhachHang uctKH = new uctKhachHang();
21 int flag = 0;
22 private void uctKhachHang_Load(object sender, EventArgs e)
23 {
24 dis_end(false);
25 HienThiDanhSachKhachHang();
26 bingding();
27 }
28 public void HienThiDanhSachKhachHang()
29 {
30 dgvDanhSachKH.DataSource = Models.KhachHangMod.FillDataSetKhachHang().Tables[0];
31 dgvDanhSachKH.Dock = DockStyle.Fill;
32 dgvDanhSachKH.RowHeadersVisible = false;
33 dgvDanhSachKH.BorderStyle = BorderStyle.Fixed3D;
34 }
35 void bingding()
36 {
37 txtIdKhachHang.DataBindings.Clear();
38 txtIdKhachHang.DataBindings.Add("Text", dgvDanhSachKH.DataSource, "IdKhachHang");
39 txtTenKH.DataBindings.Clear();
40 txtTenKH.DataBindings.Add("Text", dgvDanhSachKH.DataSource, "TenKhachHang");
41 txtDienThoaiKH.DataBindings.Clear();
42 txtDienThoaiKH.DataBindings.Add("Text", dgvDanhSachKH.DataSource, "DienThoai");
43 txtEmailKH.DataBindings.Clear();
44 txtEmailKH.DataBindings.Add("Text", dgvDanhSachKH.DataSource, "Email");
45 txtDiaChiKH.DataBindings.Clear();
46 txtDiaChiKH.DataBindings.Add("Text", dgvDanhSachKH.DataSource, "DiaChi");
47
48 }
49 void clearData()
50 {
51 txtIdKhachHang.Text = Models.connection.ExcuteScalar(String.Format("select IdKhachHang= dbo.fcgetIdKhachHang()"));
52 txtTenKH.Text = "";
53 txtDienThoaiKH.Text = "";
54 txtEmailKH.Text = "";
55 txtDiaChiKH.Text = "";
56 }
57 void dis_end(bool e)
58 {
59 //txtIdKhachHang.Enabled = e;
60 txtTenKH.Enabled = e;
61 txtDienThoaiKH.Enabled = e;
62 txtEmailKH.Enabled = e;
63 txtDiaChiKH.Enabled = e;
64 btnLuu.Enabled = e;
65 btnHuy.Enabled = e;
66 btnThemMoi.Enabled = !e;
67 btnXoa.Enabled = !e;
68 btnSua.Enabled = !e;
69 }
70 private void btnLuu_Click(object sender, EventArgs e)
71 {
72 string _idKhachHang = "";
73 try
74 {
75 _idKhachHang = txtIdKhachHang.Text;
76 }
77 catch { }
78 string _tenKhachHang = "";
79 try
80 {
81 _tenKhachHang = txtTenKH.Text;
82 }
83 catch { }
84 string _dienthoai = "";
85 try
86 {
87 _dienthoai = txtDienThoaiKH.Text;
88 }
89 catch { }
90 string _email = "";
91 try
92 {
93 _email = txtEmailKH.Text;
94 }
95 catch { }
96 string _diachi = "";
97 try
98 {
99 _diachi = txtDiaChiKH.Text;
100 }
101 catch { }
102 if (flag == 0)
103 {
104
105
106 if (_idKhachHang == "" || _tenKhachHang == "")
107 MessageBox.Show("Hãy nhập đầy đủ thông tin");
108 else
109 {
110 int i = 0;
111 i = Controllers.KhachHangCtrl.InSertKhachHang(_idKhachHang,_tenKhachHang,_dienthoai,_email,_diachi);
112 if (i > 0)
113 {
114 MessageBox.Show("Thêm mới thành công");
115 HienThiDanhSachKhachHang();
116 }
117 else
118 MessageBox.Show("Thêm mới không thành công");
119 }
120 }
121 else
122 {
123 int i = 0;
124 i = Controllers.KhachHangCtrl.UpdateKhachHang(_idKhachHang, _tenKhachHang, _dienthoai, _email, _diachi);
125 if (i > 0)
126 {
127 MessageBox.Show(" Sửa thành công");
128 HienThiDanhSachKhachHang();
129 //uctKhachHang_Load(sender, e);
130 }
131 else
132 MessageBox.Show("Sửa không thành công");
133 }
134 uctKhachHang_Load(sender, e);
135
136 }
137
138 private void btnThemMoi_Click(object sender, EventArgs e)
139 {
140 flag = 0;
141 clearData();
142 dis_end(true);
143 }
144
145 private void btnSua_Click(object sender, EventArgs e)
146 {
147 flag = 1;
148 dis_end(true);
149 }
150
151 private void btnXoa_Click(object sender, EventArgs e)
152 {
153 string _idKhachHang = "";
154 try
155 {
156 _idKhachHang = txtIdKhachHang.Text;
157 }
158 catch { }
159 DialogResult dr = MessageBox.Show("Bạn có chắc chắn xóa ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
160 if (dr == DialogResult.Yes)
161 {
162 int i = 0;
163 i = Controllers.KhachHangCtrl.DeleteKhachHang(_idKhachHang);
164 if (i > 0)
165 {
166 MessageBox.Show(" Xóa thành công");
167 HienThiDanhSachKhachHang();
168 uctKhachHang_Load(sender, e);
169 }
170 else
171 MessageBox.Show("Xóa không thành công");
172 }
173 else
174 return;
175 }
176
177 private void btnHuy_Click(object sender, EventArgs e)
178 {
179 uctKhachHang_Load(sender, e);
180 dis_end(false);
181 }
182
183 private void txtDienThoaiKH_KeyPress(object sender, KeyPressEventArgs e)
184 {
185 if (!Char.IsDigit(e.KeyChar) && !Char.IsControl(e.KeyChar))
186 {
187 e.Handled = true;
188 }
189 }
190
191 }
192 }